SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.002946s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1018145 LIMIT 1 [ RunTime:0.001209s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1018145 [ RunTime:0.003855s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (505836,840658,564718,284983,582448,450975,652516,916732,255195,608979,280158,27448,72168,628316,606359,645259,1016772,6047,658033,536745,712742,199215,475015,823856,878959,520128,785725,363881,673520,353545,60867,234988,68248,715966,486242,968994,865187,924314,610296,686501,935811,152828,880276,626398,775290,172386,69024,140466,852128,850674,1026901,868646,1007782,400165,930233,945390,361789,504584,937943,1032305) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001744s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1018145 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000497s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1018145 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.003593s ]