SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001312s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 959201 LIMIT 1 [ RunTime:0.004458s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 959201 [ RunTime:0.001513s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (509288,657470,380146,132348,330825,134512,389536,820152,593847,695472,287649,713975,446991,209763,354526,1038944,595432,372770,898470,737070,507875,848511,369704,117993,659540,261952,376045,46662,952096,402147,148163,741561,939481,844632,941436,599046,400426,276458,47073,325045,675478,602168,409078,655038,737754,300625,380627,591334,565373,332756,657999,502825,480747,110771,441111,215780,720158,409355,700810,37470) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.005079s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 959201 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000375s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 959201 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000620s ]