SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001139s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 414050 LIMIT 1 [ RunTime:0.000410s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 414050 [ RunTime:0.001884s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (545079,932830,400744,278454,2891,446797,528526,440039,499887,943940,941009,454564,803521,350461,118297,396219,434367,786029,503353,507864,318016,1038879,143445,538596,566758,894029,832580,479650,610407,93122,96048,651124,259082,931013,324217,55195,465842,912045,197998,137367,53134,560818,165132,655442,699871,715201,734930,785120,114953,584886,187885,308736,186110,92726,240477,1007771,401443,765930,1010517,645371) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001096s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 414050 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000413s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 414050 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000483s ]