SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001164s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 419740 LIMIT 1 [ RunTime:0.000464s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 419740 [ RunTime:0.001582s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (197750,486151,418265,837262,903636,639372,571181,697630,35813,382466,420722,684991,524215,1045161,719506,983018,493043,939397,145441,888341,627171,206749,36173,885084,504806,1028426,769618,727108,486398,274858,569372,310096,72744,1046296,377897,631412,714003,499450,694854,91534,16012,912397,168296,998639,829661,145668,995429,256761,181461,1027932,909302,147598,451888,320980,924143,407017,223376,62517,892454,993414) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.000976s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 419740 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000318s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 419740 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000510s ]