SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001234s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1014709 LIMIT 1 [ RunTime:0.000353s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1014709 [ RunTime:0.001611s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (107578,139495,213812,117881,775934,764801,387327,344791,257134,56312,85293,1045670,705423,666474,839806,260355,344605,1018926,890300,642217,420237,159884,46733,302140,247825,588623,345917,953699,721695,477405,938137,258218,1033111,291276,155389,1003280,84385,280859,574883,78925,629838,224657,854827,668868,778430,696137,479413,392133,208132,980550,499420,800386,294473,749441,353761,883163,1000130,762495,66914,1043893) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.002379s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1014709 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.003948s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1014709 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000455s ]