SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001149s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 437953 LIMIT 1 [ RunTime:0.000410s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 437953 [ RunTime:0.002391s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (256924,859670,843007,984591,295742,843265,347698,115875,879060,788216,394819,32889,190690,973737,110076,77870,718539,760181,310718,501657,170643,148108,365122,374367,332237,108050,749037,742087,1040043,826511,154868,779545,725489,829042,321538,1021230,820512,356699,513341,46750,962189,621282,412565,714087,874390,1039590,664865,388621,870054,304819,966459,393748,366247,733198,216536,612742,416943,1011641,765638,110514) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001551s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 437953 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000446s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 437953 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.001202s ]