SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001108s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 983654 LIMIT 1 [ RunTime:0.000318s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 983654 [ RunTime:0.001431s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (1041689,906651,411582,297759,134219,259089,416143,681752,30757,730894,891630,238961,974432,230839,168305,880899,269927,105055,330911,520882,157282,128924,1011091,627000,984753,168918,305608,287789,107230,405599,879700,972515,575436,182200,758130,860409,701839,932206,679600,43295,494457,869869,311510,197217,731297,848390,966829,21030,547315,561549,72838,253792,950006,434825,889320,156905,857226,432057,621731,954727) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001073s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 983654 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000357s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 983654 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000424s ]