SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.004511s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1039246 LIMIT 1 [ RunTime:0.003686s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1039246 [ RunTime:0.011066s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (355516,674389,80183,935318,25247,1040949,895652,502308,966535,408300,197561,395866,16485,123715,964971,731461,189742,740810,628594,937883,527016,672496,420143,950080,133015,333923,553590,1057,864924,870154,944518,196508,962629,132472,1037104,377621,586781,706009,40048,415689,842339,478980,565331,151236,212300,562276,758457,474750,914571,902116,806968,5255,469504,845174,161762,308235,684697,92448,907564,563) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001239s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1039246 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.002290s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1039246 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000818s ]