SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001269s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1007391 LIMIT 1 [ RunTime:0.000486s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1007391 [ RunTime:0.001792s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (41427,300876,41464,782033,708321,645225,802544,872362,44824,593448,716180,42043,736646,481518,686390,1028998,141770,814170,73214,19282,63609,459915,808881,3981,314997,542359,483182,380887,70404,952521,614845,177736,664470,125733,28491,72760,987073,71544,1016248,544162,720963,369978,538820,596703,211313,801748,306978,639588,477779,555390,716943,373753,752390,225232,276755,594834,1041763,959044,635335,414796) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001198s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1007391 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000450s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1007391 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000569s ]