SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001154s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1020503 LIMIT 1 [ RunTime:0.000337s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1020503 [ RunTime:0.003523s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (28681,416118,934859,47541,669313,174539,181035,808918,170684,402669,629918,850419,868923,527732,165106,860867,706142,601636,136256,87178,6985,1001659,632293,18014,388945,544373,648313,771116,225144,338138,402436,452441,315652,831755,12328,643092,30679,113068,466119,256509,373648,315974,847362,116746,224397,644974,809185,37491,482058,111284,751275,527191,1048149,599241,808766,54534,224767,635982,856465,883882) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001226s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1020503 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.001211s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1020503 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000536s ]