SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001172s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 436028 LIMIT 1 [ RunTime:0.000358s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 436028 [ RunTime:0.001924s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (294635,376943,641200,839669,77861,35634,921190,200062,459174,246592,918999,662990,335032,498896,250876,546723,304550,234820,683958,452964,922472,723553,36639,79195,734141,620377,999767,94989,910520,662934,1035848,464818,623631,631219,128184,467993,795138,392317,215034,1007834,69737,805438,607737,565746,672151,977413,962292,929702,600939,745032,317913,624301,446411,803782,610357,687387,908713,99861,691931,552109) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001089s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 436028 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000414s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 436028 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000553s ]