SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001170s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 258413 LIMIT 1 [ RunTime:0.000442s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 258413 [ RunTime:0.002432s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (56968,76247,268311,276524,704654,648324,760800,240287,583378,39832,519525,118002,150039,334074,902854,750157,413931,130335,52442,667688,58138,926452,361254,867620,821623,734738,333759,540072,1037625,527886,789185,494029,980685,66393,57507,591017,652093,359394,974733,71809,410864,584881,824862,124596,221805,937257,754731,385484,911192,211701,979853,818501,80793,998201,519204,1015604,62524,109478,87659,500564) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001054s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 258413 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000405s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 258413 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000496s ]