SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001099s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 441801 LIMIT 1 [ RunTime:0.000385s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 441801 [ RunTime:0.007414s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (80340,185736,193094,8637,289706,145925,329539,5877,576906,942329,701597,646117,640256,140345,55299,664345,138256,404218,431754,125296,154782,419913,1057,1038634,127912,112732,1029645,119891,28279,266735,904169,612773,961245,140913,488223,375594,24049,633563,901918,559731,953992,41056,560358,191651,938626,968447,415700,363971,621438,879518,992254,180562,830697,541430,498988,1024029,845326,1019542,712164,909940) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.002308s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 441801 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000517s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 441801 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000595s ]