SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001235s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1020423 LIMIT 1 [ RunTime:0.001327s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1020423 [ RunTime:0.002536s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (979463,450124,789904,133298,929017,468189,813589,707089,715963,618292,190795,875237,323724,218697,229110,602963,187941,475449,507150,884384,457704,808271,787813,778501,436675,627712,189907,1046525,733992,768774,890293,23896,20154,335661,942736,957874,428343,148696,333586,887426,571475,367835,727674,783569,353701,905845,397734,283574,802486,501557,977795,277493,649191,161868,584430,833353,7292,649850,545409,934594) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001304s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1020423 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000392s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1020423 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000528s ]