SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.002059s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 423483 LIMIT 1 [ RunTime:0.000373s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 423483 [ RunTime:0.002258s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (888848,743012,451508,239910,94493,521330,262734,842849,73840,945828,947645,1025327,507104,217710,791343,747533,913023,404713,761609,1044103,513368,645236,695354,893156,361249,724382,159083,635565,783292,914190,935170,908778,556051,8553,613671,789483,519416,994100,497575,218468,689459,739528,332673,852043,538328,307966,736630,889671,352349,92432,771292,713994,936534,418214,885922,506885,403987,650259,304940,830779) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.002382s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 423483 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.003287s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 423483 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.003958s ]