SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001196s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 489829 LIMIT 1 [ RunTime:0.000350s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 489829 [ RunTime:0.001636s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (620071,771627,496946,92295,123104,404057,298398,444910,1011485,479794,365460,961980,569790,939910,628835,108073,468165,963481,1025118,278834,533816,584487,147643,825145,366301,413782,405908,71104,480715,886742,572956,769166,243319,839043,429903,637185,894885,802587,151490,408512,943665,693179,242804,883891,829931,806938,203587,953127,862409,231227,981666,406449,239295,707575,274473,505048,441425,50104,159982,432571) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001036s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 489829 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000377s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 489829 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000415s ]