SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001374s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 103933 LIMIT 1 [ RunTime:0.002284s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 103933 [ RunTime:0.001953s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (105781,30202,854767,577885,992016,695240,568315,134708,714880,45176,58671,913639,624969,1013446,1036939,353843,41068,251223,116611,760793,235386,19042,5746,703462,404053,99883,585786,410435,767049,986347,964983,693736,623634,958406,487977,144494,596074,855520,537669,551649,1003171,419673,243934,985727,588310,122609,717718,234014,603597,492014,164700,787370,678134,350241,19562,139085,786951,447366,877073,164170) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001313s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 103933 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000388s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 103933 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000549s ]