SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001172s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 452904 LIMIT 1 [ RunTime:0.000432s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 452904 [ RunTime:0.001683s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (598776,354903,333878,916888,468580,214648,410219,147067,1044634,935722,1026554,68968,972638,506743,473495,1002932,779295,201605,900501,952368,106241,830167,1045953,355036,552518,575093,373740,713027,883643,329778,758103,589441,606604,803280,937760,57737,89710,600533,480686,249245,707699,657798,898187,38288,202866,777670,613504,177112,191499,112725,884441,552930,317574,614173,188212,823671,670088,866407,138305,694709) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.000983s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 452904 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000395s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 452904 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000568s ]