SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001273s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1014701 LIMIT 1 [ RunTime:0.000422s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1014701 [ RunTime:0.002152s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (314973,930296,232774,860968,144025,578794,525097,907945,59592,906338,375454,727004,121329,134338,636014,484930,58161,48119,629936,905050,582473,899407,965262,800498,417974,481983,439917,773729,831153,372806,974006,140270,165333,743790,482661,778417,364424,539386,274878,172270,321168,412839,991617,1046376,805973,391687,529925,611499,236264,833856,572014,269497,270083,973616,759067,986630,334997,744976,188142,845890) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001228s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1014701 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000397s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1014701 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000570s ]