SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001180s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 681500 LIMIT 1 [ RunTime:0.000322s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 681500 [ RunTime:0.002006s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (565580,282674,640888,355880,146095,453178,913581,2275,747211,300769,498699,730460,145214,1047104,317245,674483,63212,354676,53239,193931,385356,737664,1001916,679028,657743,512438,865240,733473,26675,297176,94801,969850,437917,400014,151764,285082,717738,779135,646170,67724,899564,766837,634166,468058,928121,132407,285450,695259,564282,476181,474805,878372,513583,1000800,511438,959639,945792,509015,67721,702178) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001145s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 681500 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000354s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 681500 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000607s ]