SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.002762s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1000380 LIMIT 1 [ RunTime:0.002033s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1000380 [ RunTime:0.003166s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (626635,1040852,161745,72751,906001,365166,1033021,702599,83522,118975,967124,261801,290814,1031527,299478,352525,775878,895855,937303,321502,591291,673674,632596,873121,742906,1040409,930966,766124,695700,35323,378275,536029,610322,240355,429820,503413,217125,300147,594362,368213,697041,509137,182692,588064,813188,952676,972426,784640,915086,806109,223578,866912,58950,162960,778451,414108,376852,400462,368193,890119) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001119s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1000380 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000580s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1000380 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000608s ]