SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001200s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 469693 LIMIT 1 [ RunTime:0.000351s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 469693 [ RunTime:0.001774s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (3375,641627,54744,204005,384476,968857,330188,868612,866481,622050,282554,116781,709086,641685,552412,959183,184115,943742,826901,348882,63186,458007,385066,210612,950165,207899,125147,539951,243595,118113,184197,962415,568580,979112,885477,972083,1032776,874638,47863,665542,437412,1000407,735501,64292,1027893,752893,552688,1006388,446168,784930,346191,13338,626330,903016,747117,510666,1037825,512913,825588,884266) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001307s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 469693 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000379s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 469693 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000689s ]