SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001219s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 53688 LIMIT 1 [ RunTime:0.000584s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 53688 [ RunTime:0.001610s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (865019,178806,1045624,1024157,785716,295533,189199,585281,891532,645267,101575,1031473,1013978,973047,362477,134663,956094,500450,352994,608772,350607,494665,551610,876324,952758,954753,1194,596964,384140,817138,999191,655222,751017,344991,711192,472669,805507,684182,104423,521535,535983,827083,869475,345337,810395,544363,339128,353234,799977,233317,705363,804999,164447,51714,101028,334034,584668,1027401,610677,66741) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001954s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 53688 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000368s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 53688 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000534s ]