SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001140s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 145287 LIMIT 1 [ RunTime:0.000315s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 145287 [ RunTime:0.002137s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (464017,55705,620025,289961,22075,901488,1021002,268619,371914,69687,734677,160944,624024,662319,331625,812853,78650,508780,657661,942410,386958,152958,1038810,748892,479021,981791,639892,626387,954140,919185,267236,15328,861319,149446,367523,185390,651478,497895,311867,489774,263689,907764,750411,637258,144096,820725,994969,899556,498217,107508,476439,944394,780310,289543,810674,305566,496125,371602,256061,595084) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.002787s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 145287 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000378s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 145287 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000512s ]