SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001227s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 29760 LIMIT 1 [ RunTime:0.000385s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 29760 [ RunTime:0.001895s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (586891,573898,134019,293741,456692,870848,271214,385883,432093,82639,290003,65262,122370,883388,60333,700045,170817,974172,1009108,278683,919727,363097,493315,449421,728497,94709,690636,473665,921218,347933,771324,914136,769279,182734,751856,491756,670030,247825,353464,947252,803213,91947,618988,387401,669011,114585,27704,117684,40149,927044,271841,152418,750538,263852,352130,791277,215499,714640,392405,171917) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001266s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 29760 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000444s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 29760 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000594s ]