SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001191s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1028370 LIMIT 1 [ RunTime:0.000336s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1028370 [ RunTime:0.001582s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (452311,396235,1032438,947178,81914,315653,113260,746522,630315,1036761,775321,168258,653530,751768,666715,460690,116790,339734,21431,138472,8631,803330,898293,181362,410228,1030472,388830,828288,505347,420098,509750,193110,592206,1041038,827603,251741,961523,147927,380199,581965,932029,95527,750809,148692,478420,886745,481254,928616,391313,886284,617166,882123,468520,371415,141337,474180,340061,365306,292805,328433) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.002258s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1028370 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.002683s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1028370 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.001381s ]