SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001258s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1042573 LIMIT 1 [ RunTime:0.000356s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1042573 [ RunTime:0.001617s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (345430,633374,590738,797061,90043,689700,411749,615966,62958,559356,785971,810905,511793,302833,612556,807516,467272,142605,381035,152578,698681,448039,595568,362511,745188,337820,42769,963877,646554,732916,897102,795610,443362,165979,603077,942534,88088,856022,637443,285095,846069,932867,530657,214793,758151,168585,922287,847502,903506,641997,912551,381407,637890,1031097,656282,309866,710850,397162,117777,1018815) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.002944s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1042573 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.001464s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1042573 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.001614s ]