SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.004497s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 425541 LIMIT 1 [ RunTime:0.000336s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 425541 [ RunTime:0.001704s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (410684,863005,105736,111764,488866,271362,235604,324891,955444,777750,737048,442467,558257,86289,524772,897403,708889,239067,586843,110146,267806,636274,1018838,258329,587873,561710,42749,75522,755877,114043,212740,863461,1007947,316893,984614,994999,788104,731563,614383,596379,200183,797884,870281,88974,997272,679694,752288,427645,199343,471860,261767,606850,83240,880404,67094,489504,930770,181455,756233,435753) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.002211s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 425541 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.004075s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 425541 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.004366s ]