SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001234s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 494875 LIMIT 1 [ RunTime:0.000337s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 494875 [ RunTime:0.002242s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (372057,358513,638707,169446,346484,289590,200004,719165,351832,511259,886077,348211,240724,622017,203484,574775,212708,351535,1012060,5830,929991,233235,501996,120896,1047924,379990,691186,901533,158833,499515,687436,927832,381148,375235,992753,925371,405338,596794,326483,826737,847126,1015763,91110,693022,298640,308882,720456,593618,320021,12591,531703,705827,625893,807279,394853,878295,3765,692404,347139,370325) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001724s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 494875 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000396s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 494875 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000625s ]