SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001143s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 369761 LIMIT 1 [ RunTime:0.000324s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 369761 [ RunTime:0.001866s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (2009,394902,366570,915353,954363,403720,817291,614675,894909,376914,173362,450827,608905,32827,101153,504812,762240,55335,579081,941273,478320,187770,431183,1031689,105776,80252,179092,785781,59459,459677,1022409,638790,144088,188319,866667,118403,902977,897385,1014826,676580,28950,811400,212840,367849,462667,542336,451980,989237,634659,451832,567913,878071,618959,842550,129816,879224,56351,958077,810842,394908) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.002456s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 369761 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000614s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 369761 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000548s ]