SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001226s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 503594 LIMIT 1 [ RunTime:0.000335s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 503594 [ RunTime:0.001574s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (287469,741084,134127,35874,206081,187336,90576,785145,199772,27468,736406,214111,126093,590582,79774,774455,371845,710155,636607,727763,370029,448424,290226,324943,382396,913182,940143,1009957,450434,1036628,512071,1003480,165547,636780,501441,445989,336525,886845,919845,601852,367584,718323,978750,95735,512089,503241,993271,516552,738004,727367,460947,134930,477272,148792,577447,627320,878764,318229,157412,561317) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001072s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 503594 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000355s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 503594 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000609s ]