SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001465s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1037970 LIMIT 1 [ RunTime:0.000699s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1037970 [ RunTime:0.002014s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (312878,144930,454299,535160,663723,507151,845981,433692,69948,20920,227673,903033,38224,919527,709900,540267,375508,719173,312431,984400,510137,863143,399067,421056,656271,873094,554320,857954,494360,1715,98875,182400,397861,781407,842671,615191,633732,414286,326267,10762,823207,934586,229456,646540,127647,874931,893167,253856,1025908,11458,686178,5448,665205,257245,833003,812956,840296,976615,781757,121543) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001128s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1037970 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000391s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1037970 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000535s ]