SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.002234s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 321064 LIMIT 1 [ RunTime:0.000382s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 321064 [ RunTime:0.001826s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (1020243,620789,503925,427757,224306,300991,16801,715371,275043,371465,93876,781929,66120,291511,884173,337313,616346,151118,602224,4256,40633,499867,640266,1018860,957356,328271,232690,939303,525098,149488,944667,985027,556589,187522,80836,667031,758468,543578,750346,47126,751822,89394,17417,489624,419266,548580,225476,868595,660472,68477,1027938,951892,486481,384028,368909,201693,988413,232299,868513,688372) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001104s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 321064 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000352s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 321064 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.001243s ]