SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001776s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 20328 LIMIT 1 [ RunTime:0.001887s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 20328 [ RunTime:0.001894s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (794630,82844,292373,842191,577180,422731,697933,661546,804300,117106,692029,129385,145272,79106,1028443,288722,698944,760194,657480,471759,552097,358275,279689,911915,923744,356523,396321,468136,994921,256327,454408,418642,100443,308633,738847,827588,238942,736460,393102,430113,675590,225778,285160,149807,7308,930333,435123,509989,926704,1045201,733122,843430,855403,203465,622384,256165,965372,207800,221052,945337) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001190s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 20328 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.002379s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 20328 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000880s ]