SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.002023s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 175552 LIMIT 1 [ RunTime:0.000436s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 175552 [ RunTime:0.001790s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (555803,172742,611198,909657,361064,124650,692810,283553,867569,995649,661935,809068,298431,957695,1030633,307606,974875,96860,1475,1013878,565513,280950,498433,572116,656234,508460,678671,728652,104805,586493,473221,703712,316005,359000,879537,634403,945758,316440,791644,417755,288385,35362,865177,392448,396746,991809,1016494,6475,283000,855989,615246,620776,617872,373458,517424,734316,503057,321877,292412,452934) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001124s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 175552 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000400s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 175552 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000425s ]