SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001235s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 200896 LIMIT 1 [ RunTime:0.000331s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 200896 [ RunTime:0.001728s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (328316,769262,677968,286500,290286,256497,121709,223415,627817,991441,782213,353764,925642,651716,770575,765704,511334,148285,282392,669424,712655,433062,743309,1025002,660527,579982,485025,24110,36172,1040717,37408,343220,667928,472246,753439,545733,219776,564559,304265,448918,407480,301565,235786,1021277,218127,1025571,122909,1044581,1043839,1045115,276453,63909,836946,74552,628119,830431,850349,919101,723255,931612) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001253s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 200896 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000412s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 200896 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000496s ]