SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.003299s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 444710 LIMIT 1 [ RunTime:0.000407s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 444710 [ RunTime:0.001547s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (1045940,982021,824739,40762,58540,1005101,772257,421609,39414,649547,904915,956540,533185,302101,112339,89664,105881,328988,1037855,300622,227612,447530,389620,791502,1021540,366018,55786,827912,597246,462305,799885,344250,227966,467598,640166,420500,672910,46640,58175,182697,33910,488935,842589,297588,877348,958100,757958,238088,321077,516535,472456,714297,524550,692632,885958,981329,91363,781409,741181,411245) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.008599s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 444710 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000981s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 444710 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000552s ]