SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001095s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 423552 LIMIT 1 [ RunTime:0.000375s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 423552 [ RunTime:0.001588s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (845627,204845,312448,109602,656647,964868,1048655,553243,951953,541791,483427,856192,945515,805224,452989,1017197,490043,357319,154722,1047784,270604,167645,68491,855730,970576,323683,375081,604610,654011,418099,390703,189180,246422,470457,691650,1001944,900334,167684,24079,672882,977218,371646,142791,831172,652208,1022558,346907,113067,640761,956182,679070,417525,416377,1031195,674818,1030294,731031,202571,486750,292353) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001010s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 423552 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000401s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 423552 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000533s ]