SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001084s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 599428 LIMIT 1 [ RunTime:0.001007s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 599428 [ RunTime:0.002273s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (414585,1033489,1048254,760106,136111,923835,37224,970494,873948,9851,403178,287925,659959,339783,137658,880622,562679,922593,896567,898802,778735,302865,669912,945882,651821,225128,1013031,473162,690088,974900,124435,449569,183632,461547,456037,923959,408406,380564,289074,47390,655880,37451,731493,572271,273216,268454,111683,276668,537174,517850,450622,799031,991525,90485,355950,608263,409171,158448,637915,1044177) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001814s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 599428 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000660s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 599428 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.001135s ]