SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001167s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 569991 LIMIT 1 [ RunTime:0.000322s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 569991 [ RunTime:0.001550s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (490141,1045851,986349,155022,737501,1033156,307737,943828,551718,452866,798990,687364,203638,175165,231265,307916,637940,515181,1005608,575103,927945,729423,400743,818876,131447,796127,540035,97627,401391,146181,354335,916980,169543,631664,86118,703533,870667,850087,264231,409736,699800,804662,436812,739744,1026495,821357,960805,214651,523692,772360,895784,529823,724140,640821,98143,785769,237068,522266,805760,765096) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001148s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 569991 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000335s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 569991 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000580s ]