SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001241s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1035507 LIMIT 1 [ RunTime:0.001752s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1035507 [ RunTime:0.005218s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (511357,470715,657952,874861,961781,410865,866790,343080,934271,364499,192976,4134,238954,20286,442889,537973,494420,439094,844074,791472,686652,558396,728749,828949,104128,64284,345271,916167,149230,856595,181930,757275,1015882,1044907,535260,633609,558053,86142,171070,233447,150401,622335,183466,161057,817280,164384,309914,131387,206876,42170,681269,517109,286949,669578,58487,222512,928213,515606,553938,1016410) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001720s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1035507 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.004283s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1035507 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.003617s ]