SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001147s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1027067 LIMIT 1 [ RunTime:0.000397s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1027067 [ RunTime:0.001558s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (287798,719691,397825,97167,256703,357421,771407,812198,47812,780790,850119,374178,120053,797836,700101,627972,632012,1030821,195074,732203,393836,259985,1021492,367898,274915,122447,202854,627706,64700,947015,302493,820140,1027418,350427,731755,81217,682462,111388,276990,91020,251306,560770,594759,961177,933974,700465,721122,649147,353120,583198,614218,498401,489509,809312,328393,833925,185368,289890,457707,1039974) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001071s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1027067 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000503s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1027067 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000633s ]