SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001203s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 536809 LIMIT 1 [ RunTime:0.000348s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 536809 [ RunTime:0.001609s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (442595,700226,535642,20299,584875,392267,840737,640071,921777,879652,524221,348451,1040285,107465,295877,500996,211365,658052,880517,689843,268958,815626,934024,610989,676261,26928,507570,1022258,950892,509221,650325,927408,160701,36890,870320,641662,574992,422774,266232,455639,84239,726847,96478,1027638,1007244,589962,186127,662806,572694,1016263,902182,393053,635454,367507,119884,809045,131111,622649,742371,847927) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001053s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 536809 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000351s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 536809 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000555s ]