SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.002432s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 319451 LIMIT 1 [ RunTime:0.000721s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 319451 [ RunTime:0.001702s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (1043513,1017378,483703,549549,953435,275743,173117,615261,713708,220877,591303,1048864,827706,241127,805819,234787,853746,206566,169080,119535,199502,66198,374880,68097,393027,923993,587684,1045720,48535,323832,863378,286271,765441,680835,629697,348625,714409,642322,614890,42527,918142,871673,406310,248989,237636,571561,49092,534357,918813,546883,976620,354012,404501,27923,933547,693667,894043,61728,255206,179917) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001011s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 319451 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000385s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 319451 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000465s ]