SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001222s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 541231 LIMIT 1 [ RunTime:0.001465s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 541231 [ RunTime:0.001695s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (1025180,314084,702408,669307,557712,654077,511242,457220,746402,924353,97028,361333,711802,815331,449556,833313,303369,699885,333258,563417,944285,923616,309301,790998,203199,477498,786480,571053,42029,656750,23317,215574,304181,85132,391570,938504,26244,696186,948081,136324,677761,913000,790135,235688,176138,396333,666775,62539,689642,110578,135547,100372,458537,264,328601,463613,636771,74385,765650,245253) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001173s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 541231 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000506s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 541231 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.003590s ]