SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001245s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 41893 LIMIT 1 [ RunTime:0.000465s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 41893 [ RunTime:0.001839s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (642404,320900,986694,102023,272563,104810,347131,756217,800466,965809,1011043,192526,956447,518425,623921,451711,436571,82784,234581,63212,613052,70039,259491,730038,876416,815928,859615,621854,231844,840051,513761,425485,493825,878667,548593,598517,677401,852754,1033809,1008659,755132,332271,523930,279779,286712,129211,71262,407663,178175,507359,342545,908747,866446,976806,505790,41409,182224,1631,741909,302559) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001340s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 41893 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000351s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 41893 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000539s ]