SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001225s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 403193 LIMIT 1 [ RunTime:0.000283s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 403193 [ RunTime:0.001674s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (147795,841455,527978,852795,684039,192832,755132,45836,792926,1004354,504494,1017733,729605,786159,908766,634909,723721,95003,640345,645617,516990,357586,76633,800624,270281,35725,82306,858151,1014561,981232,643283,785570,137637,697142,590045,789121,876113,718521,356172,971644,745560,819448,1007519,714620,547824,100373,531400,515012,89620,38210,801107,289679,970986,436746,127912,453527,832987,444583,28224,413489) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001003s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 403193 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000363s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 403193 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.001700s ]