SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001146s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 407183 LIMIT 1 [ RunTime:0.000541s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 407183 [ RunTime:0.001888s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (110510,44591,222210,302628,786816,736576,281445,540528,348983,92145,788545,205542,595468,330747,486904,476303,745474,703864,772633,955608,119963,506130,629547,546138,513430,1037784,990895,83235,393947,581518,874470,975166,962882,146161,850906,465743,781044,672808,750619,936540,34702,977680,1006234,613545,758715,228286,535337,21371,110034,32008,327927,618517,752117,560865,803644,2916,860577,724009,634665,444139) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001062s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 407183 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000335s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 407183 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000565s ]