SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001319s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 402211 LIMIT 1 [ RunTime:0.000342s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 402211 [ RunTime:0.001484s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (748096,823459,14347,73022,463100,410436,1027046,368643,282344,571718,311842,761031,994162,899018,902348,552805,364584,620931,108002,926366,215406,151351,868735,1008267,160571,499384,1012847,840840,281421,376872,316298,539084,772917,131324,629407,946327,476844,684892,571340,618422,587169,915326,835551,741186,31724,913680,776671,10910,258053,417262,721614,717657,910474,651274,70247,927396,100080,851596,192739,639138) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.000988s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 402211 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000358s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 402211 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.001701s ]