SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001121s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1035571 LIMIT 1 [ RunTime:0.000367s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1035571 [ RunTime:0.001465s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (186685,698423,796285,497064,497875,981349,1021035,759911,764242,296149,805551,328476,131599,74890,121672,191115,172114,846005,917832,37969,722332,222674,4284,197801,25279,53992,504688,185115,346992,340348,14978,789318,368343,359770,819247,628238,777860,749097,856541,363796,484452,102060,135393,550177,910155,643266,127390,735261,1041105,332779,860490,541592,782708,170382,417628,339627,639203,914764,120192,458989) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001098s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1035571 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000379s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1035571 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000538s ]