SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001212s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 414347 LIMIT 1 [ RunTime:0.000356s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 414347 [ RunTime:0.002243s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (1029772,273033,24898,768895,77955,375254,418545,971680,344225,653939,158537,132920,551547,701636,181053,416072,199339,125279,125287,471812,61791,931436,450397,917348,904999,160814,935160,486764,387318,137903,513399,2694,708598,336106,128188,1045865,701338,798042,743930,720299,381865,812533,255785,676733,784459,406842,762955,966475,328665,902472,901662,607663,234437,124560,787543,20943,350751,486759,642126,754266) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001261s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 414347 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000376s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 414347 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000430s ]