SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001895s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1014100 LIMIT 1 [ RunTime:0.000647s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1014100 [ RunTime:0.002145s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (563406,243308,281819,986382,944946,182697,282850,99849,714365,305820,639050,251188,427296,452298,442462,783467,50831,393598,178881,420141,614272,993620,929241,690970,940193,487951,860681,920052,180810,369463,897284,818895,703011,823467,716555,314720,141015,786489,388562,363789,828714,258549,684759,574579,901247,578039,783188,354171,318141,998725,308562,1017949,486250,751480,476103,784159,516505,194888,469043,638970) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001083s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1014100 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000408s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1014100 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000976s ]