SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.002155s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 105410 LIMIT 1 [ RunTime:0.000452s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 105410 [ RunTime:0.003086s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (905922,540999,173235,722201,861672,702785,926285,936958,220995,5586,816067,207032,323729,253220,805101,742119,843487,718698,960113,334030,167609,405703,27931,910451,455219,571559,874951,887715,111910,1008133,581711,728612,975291,904335,695699,246227,913008,692243,67429,955968,469891,130267,730084,798151,126476,195990,488823,815158,680477,49694,327081,587690,293825,642962,754204,104236,341499,782299,155787,144640) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.000990s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 105410 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000371s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 105410 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000603s ]