SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001208s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 388180 LIMIT 1 [ RunTime:0.000426s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 388180 [ RunTime:0.003483s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (628110,821334,737154,89723,429171,182573,799366,708713,621240,340499,323217,726640,91736,456073,527957,383500,400173,1039666,932910,502074,262944,404402,642135,995272,9502,188798,488746,640984,466821,309378,271921,501743,545184,689040,633342,353669,687027,788228,471957,940651,761407,439723,828345,548607,972787,297758,416349,246996,254630,296610,212090,735325,848927,223888,620393,771376,265923,178249,832557,891208) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001473s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 388180 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000573s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 388180 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000425s ]