SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.002490s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 455045 LIMIT 1 [ RunTime:0.000509s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 455045 [ RunTime:0.001808s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (537408,821076,844090,689663,188730,255280,89999,149590,335060,541234,195292,673068,451711,757364,40956,51986,902198,106641,507998,870974,402098,1048501,181674,604521,118443,740335,386776,14260,722081,796668,561880,937873,237676,511343,909487,407870,873780,797089,747188,252734,786089,636708,53511,540748,112098,322347,478422,286978,191939,806763,443854,756076,807604,11185,346350,328960,951547,489315,567351,295422) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001096s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 455045 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000360s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 455045 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000398s ]