SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001143s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 40948 LIMIT 1 [ RunTime:0.000330s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 40948 [ RunTime:0.001920s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (493189,21916,320159,719453,880198,890898,726326,790043,940421,928451,138453,624021,894852,853625,1041954,101739,221066,430877,1019199,1002869,1009005,381454,392610,866369,227763,1001262,567972,853743,348596,523308,114013,659514,116974,428182,360866,570977,543178,828387,399947,76759,848060,437274,614642,1038325,1431,334947,9296,795472,967563,348164,105363,48621,995057,408707,74830,918947,1006184,952939,682429,954619) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.002025s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 40948 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000422s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 40948 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000525s ]