SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001211s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 394515 LIMIT 1 [ RunTime:0.001193s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 394515 [ RunTime:0.002095s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (738461,817223,998672,769368,975886,201420,501338,801435,977614,841076,944209,914995,59378,918386,986911,324756,549676,1019174,344603,681235,482072,383859,948314,20941,234693,605017,841581,355668,879086,478114,862855,507536,571542,700935,562837,633190,614670,437661,635229,850963,773726,641438,178922,472038,209690,404838,737929,15196,55095,843845,456562,494383,806089,1011177,415086,311221,3100,565381,643841,1003403) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.000974s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 394515 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000369s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 394515 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000696s ]