SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.005408s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 328161 LIMIT 1 [ RunTime:0.001638s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 328161 [ RunTime:0.003175s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (355552,984567,1003149,620576,1011696,146888,123287,995064,72363,113152,87271,425272,1025999,589404,151894,685524,626810,791936,640986,898734,498518,131846,262743,958053,718602,770501,366323,863289,397122,364926,808880,248000,123781,900901,151662,392514,388161,371841,613570,48741,436409,753853,408102,306571,478,389713,279871,723911,422126,992542,422057,808190,653162,82768,583216,754571,603752,866365,813070,727777) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001650s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 328161 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.002279s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 328161 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000527s ]