SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001194s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 416308 LIMIT 1 [ RunTime:0.000465s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 416308 [ RunTime:0.002012s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (312148,570047,70863,417767,1012018,182517,676847,691688,488971,704531,224652,449410,360906,550911,902460,301369,1041830,133043,977224,478283,398309,987654,431021,774349,571725,528318,545647,427610,332831,1015070,546279,921873,310293,837944,950222,135761,769254,726701,974448,42583,1001046,479691,541766,162646,998017,326436,798214,329797,119890,416976,720407,609685,46497,667607,316075,205059,782643,578033,918198,827272) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001112s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 416308 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000373s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 416308 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000543s ]