SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001320s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1045589 LIMIT 1 [ RunTime:0.000407s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1045589 [ RunTime:0.001621s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (935798,418602,609542,875842,727964,212184,418268,800393,428255,182149,226929,713494,616673,495128,1010218,445130,581582,289603,830267,250108,19312,470006,790172,186272,421868,840326,295381,907041,629705,576641,673239,467215,661979,739489,849494,136951,913463,838924,81849,287123,836235,329553,541164,847935,973109,301181,655062,695726,903077,950381,640822,832730,939766,348845,645185,491779,376030,426214,582144,371969) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001250s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1045589 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000441s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1045589 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000480s ]