SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001063s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 50844 LIMIT 1 [ RunTime:0.000971s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 50844 [ RunTime:0.001779s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (226383,515538,435471,977093,459340,197023,427169,472870,650346,385965,366195,69665,108936,89519,366743,875986,160560,749679,634584,160742,959919,100262,445072,17961,872774,840512,347488,537905,202298,749351,840698,876555,840633,653143,874049,19857,456556,948529,461162,770786,170365,867525,1011855,204055,453121,280955,39367,245666,262819,1010433,479727,701753,395768,344234,706054,744397,535115,258537,173682,963438) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001083s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 50844 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000575s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 50844 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000500s ]