SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.023295s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 101857 LIMIT 1 [ RunTime:0.004608s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 101857 [ RunTime:0.007621s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (216899,575828,519378,521019,408896,913695,1039477,106256,819436,873704,935473,940620,920824,182828,941537,345988,909155,795478,312549,128086,282717,835542,40812,538167,902374,119710,367850,19813,54481,906945,828283,316115,835843,77632,546957,886198,520000,908345,228174,1029700,211864,382848,641751,370761,620934,195850,131890,746965,151750,745702,544905,842413,162126,224090,163281,903208,906316,338021,1025441,554165) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.002624s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 101857 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000539s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 101857 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.011138s ]